Date fields: Date Input / Date Output
Control how EMu formats dates when they are input into date fields and how dates will display when they are output (retrieved from a database):
Specify the format for dates entered into fields that have a Date data type.
Usage
This Registry entry can be assigned to users, groups and system-wide:
Key | User | Group | System |
---|---|---|---|
Key 1 | User
|
Group
|
System
|
Key 2 | user | group | Setting
|
Key 3 | Setting
|
Format
|
|
Key 4 | Format
|
Date Input
|
|
Key 5 | Date Input
|
||
Value | option |
User
|
user | Setting
|
Format
|
Date Input
|
option |
Group
|
group | Setting
|
Format
|
Date Input
|
option |
System
|
Setting
|
Format
|
Date Input
|
option |
where:
option | can be: | |
DMY
|
Day Month Year | |
MDY
|
Month Day Year | |
MYD
|
Month Year Day | |
DYM
|
Day Year Month | |
YMD
|
Year Month Day | |
YDM
|
Year Day Month |
Examples
This entry is appropriate for users in the United States, where dates are entered into date fields as Month, Day, Year:
Key | Setting |
---|---|
Key 1 | System
|
Key 2 | Setting
|
Key 3 | Format
|
Key 4 | Date Input
|
Value | MDY
|
This entry is appropriate for users in Australia, where dates are entered into date fields as Day, Month, Year:
Key | Setting |
---|---|
Key 1 | System
|
Key 2 | Setting
|
Key 3 | Format
|
Key 4 | Date Input
|
Value | DMY
|
Specify the format in which dates will display in a field in a module when retrieved from a database. Only affects fields that have a Date data type.
Usage
This Registry entry can be assigned to users, groups and system-wide:
Key | User | Group | System |
---|---|---|---|
Key 1 | User
|
Group
|
System
|
Key 2 | user | group | Setting
|
Key 3 | Setting
|
Format
|
|
Key 4 | Format
|
Date Output
|
|
Key 5 | Date Output
|
||
Value | format |
User
|
user | Setting
|
Format
|
Date Output
|
format |
Group
|
group | Setting
|
Format
|
Date Output
|
format |
System
|
Setting
|
Format
|
Date Output
|
format |
where:
format |
a series of special characters recognized by the System as format characters: |
|||||||||||||||||||||||||||
|
Note: The format characters can be combined to create the desired date string, separated by any other character(s).
Examples
This setting will generate a date format applicable to the United States (e.g. 07/15/2006):
Key | Setting |
---|---|
Key 1 | System
|
Key 2 | Setting
|
Key 3 | Format
|
Key 4 | Date Output
|
Value | MM/dd/yyyy
|
This setting will generate a date format applicable to Australia (e.g. 15-07-2006):
Key | Setting |
---|---|
Key 1 | System
|
Key 2 | Setting
|
Key 3 | Format
|
Key 4 | Date Output
|
Value | dd-MM-yyyy
|
This setting will generate a custom date format: Feb 2, 84:
Key | Setting |
---|---|
Key 1 | System
|
Key 2 | Setting
|
Key 3 | Format
|
Key 4 | Date Output
|
Value | MMM d, yy
|
With this setting, dates will display with a preceding era (AD/BC); BC dates will be shown with a negative symbol, e.g. BC -664
:
Key | Setting |
---|---|
Key 1 | System
|
Key 2 | Setting
|
Key 3 | Format
|
Key 4 | Date Output
|
Value | E dd/MM/yyyy
|